<?php
include("./dbconnect.php");
$file = fopen("./country_codes_and_numeric.txt","r");
while(! feof($file))
{
	$one_line = fgets($file);
	$array_1 = explode(';',$one_line);
	//$sql = "SELECT id FROM `country` WHERE id='".$array_1[0]."'";
	//$dbh->query($sql);
	$sql_2 = "SELECT country_id FROM `country_name_translation` WHERE country_id='".$array_1[0]."'";
	$a = $dbh->query($sql_2)->fetchColumn();
	
	if($a!=$array_1[0])
	{
		echo $a.$array_1[0].'aaaaaaaa<br />';
	}
	//foreach($dbh->query($sql_2) as $row)
	{
        //echo $row['id'];
    }
}
$dbh = null;
fclose($file);
?>